The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / busition / dayoprop / dayoke.exe / DAYOPROP.DOC < prev next >

Wrap

Text File | 1992-07-28 | 335.8 KB | 4,262 lines

██▄████░ ▄███▄ ██░ ██░ ██████░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ▀████▀ ██░ ██░ ██░ ██░ ██▀▀▀██░ ▀██▀ ██░ ██░ █▀█████░ ██░ ██░ ██░ ██████░ ██▄███░ ██▄███░ ██████░ ██▄███░ ████░ ██▄███░ ██████░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██████░ ██████░ ██░ ██░ ██████░ ███░ ██████░ ██░ ██████░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░███░ ██████░ ██░ ████░ ██░███░ ██░ ██░ ██░ ██░ ▄███▄ ██░ █░ ▄███▄ ██████░ ████░ ██░ ██░ ████░ ██░ █░ ██████░ ███░███░ ██░██░ ███░█░ ██░██░ ██░ ██░ ███░███░ ██░ ███░█░ ██░ ███████░ ██░██░ █████░ ██░██░ ██░▀██░ ███░ ███████░ ███░ █████░ ██░ ██░█░██░ ██▀▀▀██░ ██░██░ ██▀▀▀██░ ██░ ██░ ██░ ██░█░██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░ ██░ █░ ██░ ██░ ██████░ ████░ ██░ ██░ ████░ ██░ █░ ██░ DAYO Property Management Version 1.0 Copyright (c) 1992 TJS LAB Inc. 5104 North Orange Blossom Trail Suite 200 Orlando, FL 32810 ╔════════════════════════════════════════════════════════════════════════════╗ ║ Support: (407) 291-3960 Sales: 291-DAYO Fax: 295-2171 BBS: 292-4921 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 3 months after date of purchase. 3. Support is available through the following methods: - Phone: (407) 292-4708 - U.S. Mail: TJS LAB, Inc., PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO Property Management, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1...... INTRODUCTION 2...... COPYRIGHT/LICENSE 2...... DISCLAIMER 2...... REQUIREMENTS *** 3...... SETUP 3...... OVERVIEW 4...... MAIN MENU 4...... ENTER YOUR NAME OR PASSWORD 5...... PROPERTY SELECT & BROWSE 6...... EDIT PROPERTY RECORD 6...... FULL SCREEN EDIT - PROPERTY.DBF 6...... ADD PROPERTY RECORD 7...... DELETE PROPERTY RECORD 7...... EDIT PROPERTY NOTES 8...... PROPERTY SUMMARY EXAMPLE 9...... FIND PROPERTY 10...... BROWSE UNIT DATABASE 10...... EDIT UNIT RECORD 11...... FULL SCREEN EDIT - UNIT DATABASE 11...... EDIT UNIT NOTES 12...... UNIT SUMMARY EXAMPLE 13...... FIND UNIT RECORD 13...... BROWSE TRANSACTION DATABASE 14...... EDIT TRANSACTION RECORD 14...... FULL SCREEN EDIT - UNIT TRANSACTION DATABASE 14...... ADD TRANSACTION RECORD 15...... RESET UNIT BALANCE 15...... FIND UNIT TRANSACTION RECORD 16...... INPUT RENT OR INCOME RECORD/TRANSACTION 18...... PRINT RECEIPT VOUCHER 19...... RECEIPT VOUCHER EXAMPLE 20...... INPUT SALE OR MISC INCOME RECORD/TRANSACTION 21...... INPUT EXPENSE OR BILL RECORD/TRANSACTION 22...... SERVICE BROWSE 23...... MAINTAIN SERVICE & MAINTENANCE RECORDS 23...... FULL SCREEN EDIT - SERVICE.DBF 24...... ADD NEW SERVICE RECORD - SERVICE.DBF 24...... FIND SERVICE ORDER 25...... EDIT SERVICE NOTES FOR WORK ORDER 25...... SERVICE & MAINTENANCE WORK ORDER EXAMPLE 26...... REPORTS 27...... PRINTER DRIVER (SETUP) 27...... PRINTER DRIVER OPTIONS 28...... CHANGE DEFAULT PRINTER DAYO Property Management, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 29...... FULL SCREEN EDIT - F2 29...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 30...... ACTIVITY REPORT 31...... EXAMPLE OF THE ACTIVITY REPORT 32...... VACANCY REPORT 32...... EXAMPLE OF THE VACANCY REPORT 33...... LATE RENT REPORT 34...... EXAMPLE OF THE LATE RENT REPORT 34...... RENEWAL OR LEASE DATE REPORT 35...... EXAMPLE OF THE LEASE RENEWAL REPORT 35...... ROLL REPORT 36...... EXAMPLE OF THE ROLL REPORT 36...... UNIT MAILING LABELS 37...... UNIT EXPANDED REPORT 37...... INCOME & EXPENSE REPORT 38...... EXAMPLE OF THE INCOME & EXPENSE REPORT 39...... PROPERTY LIST 40...... EXAMPLE OF THE PROPERTY LIST 40...... PROPERTY MAILING LABELS 41...... PROPERTY EXPANDED REPORT 42...... SERVICE/WORK ORDER LIST 43...... EXAMPLE OF THE SERVICE LIST 43...... EXPANDED SERVICE REPORT 44...... CONFIGURATION REPORT 44...... EXAMPLE OF THE CONFIGURATION REPORT 45...... VIEW REPORTS ON SCREEN 46...... REPORT VIEWING SCREEN 47...... CONFIGURATION 47...... COMPANY NAME 47...... COMPANY ADDRESS 48...... COMPANY CITY 48...... COMPANY STATE 48...... COMPANY ZIP 48...... COMPANY TELEPHONE 49...... CURRENT DIRECTORY DATABASE LOCATION 49...... DEFAULT TYPE CODE 49...... DEFAULT CLASS CODE 49...... PRINT RENT/LEASE RECEIPT VOUCHER 50...... REPORT PRINTER TYPE 50...... REPORT PRINTER PORT 50...... AUTOMATIC DAILY INDEXING 51...... COLOR MONITOR 51...... COLOR INTENSITY DAYO Property Management, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 52...... MISCELLANEOUS ROUTINES 52...... MISC Routines Menu: 53...... APPEND FROM 55...... BROWSE DATABASES 57...... COPY (.DBF) TO 59...... CREATE DATABASE 61...... DELETE RECORDS 62...... ERASE FILE 62...... EXIT TO DOS 63...... INDEX A DATABASE 64...... LIST FIELDS 67...... MODIFY DATABASE 68...... PACK DATABASE 69...... RECALL RECORDS 69...... RETURN TO MENU 69...... RUN (DOS COMMAND) 70...... SIMPLE EDITOR 71...... SORT DATABASE 72...... TYPE (PRINT) FILE 73...... ZAP DATABASE 76...... HELP SCREENS 77...... EXPANDED HELP 78...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 79...... VIEW DOCUMENTATION ONSCREEN 80...... DATABASE STRUCTURE 80...... DATABASE: PROPERTY.DBF 80...... DATABASE: UNITFILE.DBF 81...... DATABASE: DATAFILE.DBF 81...... DATABASE: SERVICE.DBF 84...... TJS 'Computer' LAB DAYO Property Management, TJS LAB, Inc. Page: 1 ■ INTRODUCTION DAYO Property Management was written to be used by any person or company that manages one (1) or more properties. Multiple units per property is also a standard feature. DAYO Property Management is by default a multiuser system, allowing almost unlimited numbers of users to have the ability to process data simultaneously using this one program while on a PC based LAN/Network. It can, however be run (like all DAYO products), as a 'standalone' application. Some of the DAYO Property Management highlights are: Multiuser (ie: Novell) Data Entry Validation Databases are dBase (tm) compatible Property Mailing Address Labels Unit Mailing Address Labels Multiple Configuration Settings Passwords (with DAYO Passwords) Reports A Few Other DAYO Modules: Menu, Alternate Menus, Inventory, Billing & Invoicing, Point of Sale (POS), Accounts Receivable, Accounts Payable, Materials Requirement Planning (MRP), Payroll, General Ledger (GL), Job Costing, Time & Billing, Membership, Sales Management System, Support Calls Management System, UPS Manifest & Rates, GUI Point of Sale, GUI BRAIN Program/Job Scheduler, Order Entry, Smart Reports, Quotes, Price Books/Lists, End of Period/Purge, Bar Code 3 of 9 Labels, Network Manager for Novell's Netware (tm), Pack Databases (Remove Deleted Records), Purchase Orders (Create From Orders/Quotes), Reset Cost Field in Inventory Database, Reset Price-Price1...Price5 Retail Fields, Index (Batch Indexing), History (Database Archiver), Passwords, Back Orders, Look Up Databases, Shipping Log, Return Management System, Cash Only POS (ie: Like A Grocery/Department Store, No Receivables), Little POS, Simple POS, Returns & Refunds, Rental POS DAYO Property Management, TJS LAB, Inc. Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No duplication of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO Property Management software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using DAYO Property Management. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk DAYO Property Management, TJS LAB, Inc. Page: 3 ■ SETUP To setup DAYO Property Mangement, run the SETUP program supplied on the DAYO Menu and the Update & Conversion disk. This SETUP program will install DAYO Property Management into a directory on your hard disk (ie: \DAYOPROP). When you run DAYO Property Management for the first time, it will create all the database, index, and configuration files it requires for operation. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO Property Management configuration. ■ OVERVIEW The first step is to insure that your configuration options/settings are properly set. The most obvious option is the company name and address, but they are all important. The next step is to add property records (option #1 from the main menu). Properties may contain multiple units, and if so, you need to create a record for each one of them (option #1 also). Before entering many of the main menu options, you will be required to select a property (option #1). When you have all the property and unit records created, you can then begin to create transaction records by receiving rent payments and/or creating expense records. Service records or work orders are created in the fourth (4th) main menu option. Use the Miscellaneous Routines to perform simple database management routines, but be very careful with this menu option. DAYO Property Management, TJS LAB, Inc. Page: 4 ■ MAIN MENU From the main menu, you have access to all the routines in the program. DAYOPROP Version 1.0, Copyright(c) 1992 TJS LAB, Inc ┌─────[July 1992]────┐ ▌ 1 Select Active Property │S M T W T F S │ ▌ 2 Receive Rent & Income ├────────────────────┤ ▌ 3 Expenses │ 1 2 3 4│ ▌ 4 Service & Work Orders │ 5 6 7 8 9 10 11│ ▌ 5 Reports & Special Routines │12 13 14 15 16 17 18│ ▌ 6 Configuration │19 20 21 22 23 24 25│ ▌ 7 Miscellaneous Database Routines │26 27 28 29 30 31 │ ▌ 8 Information │ │ ▌ Exit to Dos └────────────────────┘ ╔══════════════════════════════════╦════════════[ Active Property ]══════════╗ ║ ██▄████░ ▄███▄ ██░ ██░ ██████░ ║ ║ ║ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ║ ║ ║ ██░ ██░ ██░██░ ▀████▀ ██░ ██░ ║ No Active Property ║ ║ ██░ ██░ ██▀▀▀██░ ▀██▀ ██░ ██░ ║ ║ ║ █▀█████░ ██░ ██░ ██░ ██████░ ║ ║ ║ ╚═════════════════════════════════════════╣ ║ ██▄███░ ██▄███░ ██████░ ██▄███░ ████░ ██▄███░ ██████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ██████░ ██░ ██░ ██████░ ███░ ██████░ ██░ ██████░ Management ║ ║ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░███░ ██████░ ██░ ████░ ██░███░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Select the active property database or MAINTENANCE ■ ENTER YOUR NAME OR PASSWORD Before any routine can be entered, you must enter something at the prompt for your name, or a valid password if you have installed DAYO Passwords into your Property Management directory. ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: tj ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 5 ■ PROPERTY SELECT & BROWSE Select the first option on the main menu to access the browse of the property database (PROPERTY.DBF). This database contains data/information for each property. To select a property as the default for inputting expenses and income (ie: rent), simply press enter when the property is highlighted. Many routines are available from this browse which include: Editing, adding records, deleting records, browsing unit database, browsing transaction database, edit notes, print property summary, and find functions. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Name: Rent House Property: 123456 ║ ║ Contact: Tom Johnson Phone: 555-555-1212 ║ ║ Address: 1234 Easter Lane, Road #2 Picture: ║ ║ Data File: D123456 ║ ║ City/State/Zip: NEW ORLEANS, LA 99999-9999 Unit File: U123456 ║ ║ Type: XXX Class: XXX Date: 12/12/91 Last Date: 12/12/91 < Notes > ║ ╟─────────────────────[ SELECT/BROWSE/EDIT PROPERTIES ]──────────────────────╢ ║ PROPERTY NAME CONTACT ║ ║──────────╥────────────────────────────────╥────────────────────────────────║ ║ 123456 ║ Rent House ║ Tom Johnson ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc(Exit) F2(Edit) Alt F2(Edit) Ctrl N(Add) Ctrl U(Delete) Enter(Select) Alt U(Units) Alt T(Transactions) Alt N(Notes) Alt P(Print) Find: F5(Property) F6(Name) F7(Address/Street) F8(Phone) F9(Contact) 3/6 DAYO Property Management, TJS LAB, Inc. Page: 6 ■ EDIT PROPERTY RECORD Press F2 to edit the currently highlighted property record. The display at the top of the screen becomes the input screen. ■ FULL SCREEN EDIT - PROPERTY.DBF Press F2 to edit all the fields (including any you add) onto the screen. ┌────────────────────[ FULL SCREEN EDIT - PROPERTY.DBF ]─────────────────────┐ │ PROPERTY: 123456 │ │ NAME: Rent House │ │ CONTACT: Tom Johnson │ │ ADDRESS: 1234 Easter Lane Road │ │ ADDRESS2: │ │ CITY: NEW ORLEANS │ │ STATE: LA │ │ ZIP: 99999-9999 │ │ PHONE: 555-555-1212 │ │ FAX: 555-555-5555 │ │ DATAFILE: D123456 │ │ UNITFILE: U123456 │ │ DATE: 12/12/12 │ │ LASTDATE: 12/12/12 │ │ TYPE: XXX │ │ CLASS: XXX │ │ CONDITION: VERY GOOD │ │ PICTURE: │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ ADD PROPERTY RECORD Press Ctrl N to add a property record. DAYO Property Management, TJS LAB, Inc. Page: 7 ■ DELETE PROPERTY RECORD Press Ctrl U to mark a record for deletion. Note, a record marked for deletion will be permanently removed from the database ONLY after a PACK is performed using Misc Routines. ■ EDIT PROPERTY NOTES Press Alt N to edit the notes for the highlighted property. ┌───────────────────[ EDIT PROPERTY NOTES FOR: Rent House ]──────────────────┐ │Type in anything you want (up to 18 pages) │ │for this property... │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) DAYO Property Management, TJS LAB, Inc. Page: 8 ■ PROPERTY SUMMARY EXAMPLE Press Alt P to print a property summary. This report is a 1 page report containing all the key fields. The notes are also included (can be multiple pages). ------------------------ --- PROPERTY SUMMARY --- ------------------------ Your Company Name Date: 07/26/92 5104 N. Orange Blossom Trail Suite 200 Orlando, FL 32810 (407) 291-3960 ------------------------------------------------------------------------------ Property: 123456 Name: Rent House Contact: Tom Johnson Address: 1234 Easter Lane Road NEW ORLEANS, LA 99999-9999 Phone: 555-555-1212 Fax: 555-555-1213 Data File: D123456 Unit File: U123456 Date Created: Thursday, 12 December 1992 Last Date: Thursday, 12 December 1992 Type: a Class: a Picture File: asdf ------------------------------------------------------------------------------ Notes Follow: ------------------------------------------------------------------------------ DAYO Property Management, TJS LAB, Inc. Page: 9 ■ FIND PROPERTY Press F5 to locate a property record by its property number. ┌─────────────────────────────────────────────────────────────┐ │ Enter PROPERTY: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to locate a property record by its name. ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to locate a property record by its address or street. ┌─────────────────────────────────────────────────────────────┐ │ Enter ADDRESS: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to locate a property record by its telephone number. ┌─────────────────────────────────────────────────────────────┐ │ Enter PHONE: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F9 to locate a property record by its CONTACT name. ┌─────────────────────────────────────────────────────────────┐ │ Enter CONTACT: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Property Management, TJS LAB, Inc. Page: 10 ■ BROWSE UNIT DATABASE Press Alt U to browse/maintain the unit database. From this browse, you can view/edit all the units (ie: apartments). Options include editing, adding records, deleting records, editing notes, and printing a unit summary report. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Unit: 234234 Name: Tom Johnson ║ ║ Phone: 555-555-5555 Type: REN ║ ║ Security Deposit: 137.00 Class: REN ║ ║ Amount/Rent/Payment: 500.00 Picture: ║ ║ Begin Date: 07/19/92 End Date: 01/15/93 Last Date: 07/26/92 ║ ║ Comments: Very good and timely < Notes > ║ ╟───────────────────[ UNIT DATABASE FOR Rent House (123456) ]────────────────╢ ║UNIT NAME PHONE SECURITY ║ ║─────────────╥────────────────────────────────╥────────────────╥────────────║ ║234234 ║ Tom Johnson ║ 555-555-5555 ║ 200.00 ║ ║234235 ║ Sally Morgan ║ 555-555-5454 ║ 200.00 ║ ║234236 ║ John Smith ║ 555-555-0000 ║ 200.00 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc(Exit) F2(Edit) Alt F2(Edit) Ctrl N(Add) Ctrl U(Delete) Alt N(Notes) Alt P(Print) Find: F5(Unit) F6(Name) ■ EDIT UNIT RECORD Press F2 to edit the unit records in the display at the top of the screen. DAYO Property Management, TJS LAB, Inc. Page: 11 ■ FULL SCREEN EDIT - UNIT DATABASE Press Alt F2 to edit all the fields (including any you add), in the unit database for the selected property. ┌─────────────────────[ FULL SCREEN EDIT - U123456.DBF ]─────────────────────┐ │ UNIT: 234234 CONDITION: │ │ NAME: Tom Johnson │ │ PHONE: 555-555-5555 │ │ SECURITY: 200.00 │ │ AMOUNT: 500.00 │ │ BEGINDATE: 07/19/92 │ │ ENDDATE: 01/15/93 │ │ LASTAMOUNT: 101.00 │ │ LASTPAY: 07/26/92 │ │ LASTDATE: 07/26/92 │ │ DATE: 07/19/92 │ │ COMMENTS: Very good about making payments │ │ PICTURE: │ │ TYPE: REN │ │ CLASS: REN │ │ │ │ ADDRESS: │ │ ADDRESS2: │ │ CITY: │ │ STATE: │ │ ZIP: │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ EDIT UNIT NOTES Press Alt N to edit the notes specific to the currently highlighted unit. ┌───────────────────────[ EDIT UNIT NOTES FOR: 234234 ]──────────────────────┐ │ │ │Write anything you want │ │in this space up to 18 pages... │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) DAYO Property Management, TJS LAB, Inc. Page: 12 ■ UNIT SUMMARY EXAMPLE Press Alt P to print a unit summary. This report contains all the key fields for the current unit. The unit's notes can also be printed. --------------------------- --- UNIT/TENANT SUMMARY --- --------------------------- Your Company Name Date: 07/26/92 5104 N. Orange Blossom Trail Suite 200 Orlando, FL 32810 (407) 291-3960 ------------------------------------------------------------------------------ Property: (123456) Rent House Unit: 234234 Name: Tom Johnson Comments: Very good about making payments Begin Date: Sunday, 19 July 1992 End Date: Friday, 15 January 1993 Security: 200.00 Rent/Amount: 500.00 Last Payment: 101.00 Last Pay: Sunday, 26 July 1992 Phone: 555-555-1010 Date Created: Sunday, 19 July 1992 Last Date: Sunday, 26 July 1992 Type: REN Class: REN Picture File: ------------------------------------------------------------------------------ Notes Follow: ------------------------------------------------------------------------------ Write in anything your desire, up to 18 pages... DAYO Property Management, TJS LAB, Inc. Page: 13 ■ FIND UNIT RECORD Press F5 to find a unit based on the UNIT number. ┌─────────────────────────────────────────────────────────────┐ │ Enter UNIT: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a unit based on the UNIT name. ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ ■ BROWSE TRANSACTION DATABASE Press Alt T from the property browse to browse all transactions. It is recommended that you only viwe the data here. Use the main menu options like 'Receive Rent' and 'Expenses' to create the records. Options here include editing records, adding records, deleting records, reseting the balance, and finding a transaction record. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Unit: 234234 Check No: 10001 Security: 1,230.23║ ║ Name: 34 Amount: 234.00║ ║ Date: / / Type: Class: Balance: 34,340.34║ ║ Comments: On time this time ║ ╟───────────[ DATA/TRANSACTION DATABASE FOR Rent House (123456) ]────────────╢ ║UNIT NAME CHECKNO AMOUNT ║ ║─────────────╥────────────────────────────────╥──────────────╥──────────────║ ║234234 ║ Tom Johnson ║ 10001 ║ 234.00 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc(Exit) F2(Edit) Alt F2(Edit) Ctrl N(Add) Ctrl U(Delete) Alt R (Reset Balance) Find: F5(Date) F6(Unit) F7(Name) F8(Checkno) 1/35 DAYO Property Management, TJS LAB, Inc. Page: 14 ■ EDIT TRANSACTION RECORD Press F2 to edit the currently highlighted transaction record. ■ FULL SCREEN EDIT - UNIT TRANSACTION DATABASE Press Alt F2 to display and edit all the fields (including any you add) on the screen. ┌─────────────────────[ FULL SCREEN EDIT - D123456.DBF ]─────────────────────┐ │ UNIT: 234234 │ │ NAME: Tom Johnson │ │ CHECKNO: │ │ AMOUNT: 234.00 │ │ BALANCE: 34340.34 │ │ SECURITY: 1230.23 │ │ DATE: 12/12/91 │ │ TYPE: │ │ CLASS: │ │ BY: │ │ COMMENTS: Pays Well │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ ADD TRANSACTION RECORD It is highly recommended that all transactions be entered/added through routines on the main menu (ie: Rent & Expense). If you do add a record, you must insure it has a valid CLASS code (INC or EXP). ╔════════════════════════════════════════════════════════════════════════════╗ ║ Select (Account) Class -> INC - Income or Rent ║ ║ EXP - Expense or Bill ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 15 ■ RESET UNIT BALANCE Press Alt F1 to reset the balance field. The balance is a running total indexed on the date field, beginning at the first record, or from the date you input. The progress of the reset is displayed onto the screen. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ Enter START DATE for computing a RESET of the BALANCE: 07/29/82 ║ ║ Name/Description Date Amount Balance ║ ║ Legal Accounting 07/19/92 34.00 37,000.00 ║ ║ More Misc Expenses 07/19/92 10.00 36,990.00 ║ ║ Office Supplies 07/19/92 300.00 36,690.00 ║ ║ Legal Accounting 07/19/92 30.00 36,660.00 ║ ║ Legal Accounting 07/19/92 100.00 36,560.00 ║ ║ More Misc Expenses 07/19/92 100.00 36,460.00 ║ ║ Office Supplies 07/19/92 200.00 36,260.00 ║ ║ Legal Accounting 07/19/92 50.00 36,210.00 ║ ║ More Misc Expenses 07/19/92 350.00 35,860.00 ║ ║ Office Supplies 07/19/92 300.00 35,560.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Alt R (Reset Balance) ■ FIND UNIT TRANSACTION RECORD Press F5 to find a unit transaction based on the DATE. ┌─────────────────────────────────────────────────────────────┐ │ Enter DATE: 07/26/92 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a unit transaction based on the UNIT number. ┌─────────────────────────────────────────────────────────────┐ │ Enter UNIT: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to find a unit transaction based on the unit name. ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find a unit transaction based on the check number. ┌─────────────────────────────────────────────────────────────┐ │ Enter CHECKNO: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Property Management, TJS LAB, Inc. Page: 16 ■ INPUT RENT OR INCOME RECORD/TRANSACTION This is a main menu routine that lets you input income records including rents, security deposits, sales, and miscellaneous incomes. ╔════════════════[ INPUT RENT OR INCOME RECORD/TRANSACTION ]═════════════════╗ ║ ║ ║ Select Type of Income -> Rent Payment ║ ║ Security Deposit ║ ║ Sale ║ ║ Other/Misc ║ ║ Exit ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █▄██ ███ █ █ ███ █ ███ █ █ ███ ███ █ █ ███ ║ ║ █ █ █ ██ █ █ █ █ ██ █ █ █ █ ██ ██ █ ║ ║ ████ ██ ████ █ ▀▀▀▀█ █▄██▄ ▄██▄█ █ ████ █ █ █ █████ ██ ║ ║ █ █ █ █ ██ █ █▀▀▀█ █ █ █ █ █ █ ██ █ █ █ █ █ █ █ ║ ║ █ ██ ███ █ █ █ ▀██▀█ █ █ ▀██▀█ ███ █ █ ███ ███ █ █ ███ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Option) DAYO Property Management, TJS LAB, Inc. Page: 17 If you select a RENT or SECURITY payment option, you are first prompted to select the unit making the payment. Use the find keys (ie: F5, F6) to locate the record if there are many, else just arrow down to the desired record. ╔════════════════[ INPUT RENT OR INCOME RECORD/TRANSACTION ]═════════════════╗ ║ ║ ║ Select Type of Income -> Rent Payment ║ ║ ║ ║ Select Unit -> UNIT NAME ║ ║ ───────────────────╥──────────────────────────────────────║ ║ 234234 ║ Tom Johnson ║ ║ 234235 ║ Sally Morgan ║ ║ 234236 ║ Herman Munster ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █▄██ ███ █ █ ███ █ ███ █ █ ███ ███ █ █ ███ ║ ║ █ █ █ ██ █ █ █ █ ██ █ █ █ █ ██ ██ █ ║ ║ ████ ██ ████ █ ▀▀▀▀█ █▄██▄ ▄██▄█ █ ████ █ █ █ █████ ██ ║ ║ █ █ █ █ ██ █ █▀▀▀█ █ █ █ █ █ █ ██ █ █ █ █ █ █ █ ║ ║ █ ██ ███ █ █ █ ▀██▀█ █ █ ▀██▀█ ███ █ █ ███ ███ █ █ ███ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Option) 2/3 DAYO Property Management, TJS LAB, Inc. Page: 18 Press enter on the desired highlighted record to display an input screen for the transaction. ╔════════════════[ INPUT RENT OR INCOME RECORD/TRANSACTION ]═════════════════╗ ║ Unit: 234234 Name: 234234 ║ ║ Phone: 555-555-1212 Type: REN ║ ║ Security Deposit: 137.00 Class: REN ║ ║ Amount/Rent/Payment: 12.00 Picture: ║ ║ Begin Date: 07/19/92 End Date: 01/15/93 Last Date: 07/26/92 ║ ║ Comments: Pays Well ║ ║ Last Payment Amount: 101.00 on Sunday, 26 July 1992 ║ ║ Select Type of Income -> Rent Payment ║ ║ ║ ║ Enter Amount of Rent: 12.00 ║ ║ Check Number: (ie: 123456, CASH, I.O.U., etc) ║ ║ Type: REN ║ ║ Class: INC ║ ║ Comments: ║ ║ ║ ║ █▄██ ███ █ █ ███ █ ███ █ █ ███ ███ █ █ ███ ║ ║ █ █ █ ██ █ █ █ █ ██ █ █ █ █ ██ ██ █ ║ ║ ████ ██ ████ █ ▀▀▀▀█ █▄██▄ ▄██▄█ █ ████ █ █ █ █████ ██ ║ ║ █ █ █ █ ██ █ █▀▀▀█ █ █ █ █ █ █ ██ █ █ █ █ █ █ █ ║ ║ █ ██ ███ █ █ █ ▀██▀█ █ █ ▀██▀█ ███ █ █ ███ ███ █ █ ███ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Option) 2/3 ■ PRINT RECEIPT VOUCHER If you set the configuration option to print a receipt voucher, you will be prompted to print it next. ╔════════════════════════════════════╗ ╔════════════════════════════════════════════════════════╗ ╔════════════════════════════════════════════════════════════════════════════╗ ║ Print Receipt Voucher? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ ╚════════════════════════════════════════════════════════╝ ╚════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 19 ■ RECEIPT VOUCHER EXAMPLE ----------------------- --- RECEIPT VOUCHER --- ----------------------- Your Company Name Date: 07/26/92 5104 N. Orange Blossom Trail Suite 200 Orlando, FL 32810 (407) 291-3960 ------------------------------------------------------------------------------ Property: 123456 Name: Rent House Contact: Tom Johnson Address: 1234 Easter Lane Road NEW ORLEANS, LA 99999-9999 ------------------------------------------------------------------------------ Phone: 555-555-1212 Fax: 555-555-1213 ------------------------------------------------------------------------------ Unit: 234234 Name: Tom Johnson Phone: 555-555-1001 Type: REN Class: REN ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ *** Amount Received: 12.00 *** ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ DAYO Property Management, TJS LAB, Inc. Page: 20 ■ INPUT SALE OR MISC INCOME RECORD/TRANSACTION The input of a sale or miscellaneous payment/receipt record brings up a input screen like the following: ╔════════════════[ INPUT RENT OR INCOME RECORD/TRANSACTION ]═════════════════╗ ║ ║ ║ Select Type of Income -> Sale ║ ║ ║ ║ Enter Amount of Sale: 0.00 ║ ║ Check Number: ║ ║ Unit: SALE ║ ║ Name: SALE ║ ║ Type: SAL ║ ║ Class: INC ( 'INC' or 'EXP' ) ║ ║ Comments: ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █▄██ ███ █ █ ███ █ ███ █ █ ███ ███ █ █ ███ ║ ║ █ █ █ ██ █ █ █ █ ██ █ █ █ █ ██ ██ █ ║ ║ ████ ██ ████ █ ▀▀▀▀█ █▄██▄ ▄██▄█ █ ████ █ █ █ █████ ██ ║ ║ █ █ █ █ ██ █ █▀▀▀█ █ █ █ █ █ █ ██ █ █ █ █ █ █ █ ║ ║ █ ██ ███ █ █ █ ▀██▀█ █ █ ▀██▀█ ███ █ █ ███ ███ █ █ ███ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Option) DAYO Property Management, TJS LAB, Inc. Page: 21 ■ INPUT EXPENSE OR BILL RECORD/TRANSACTION This main menu routine allows you to maintain a record of everything you spend on a property. A table is presented each time you enter the routine. Select an expense record, or press Ctrl N to add a new one. ╔════════════════[ INPUT EXPENSE OR BILL RECORD/TRANSACTION ]════════════════╗ ║ Name: Rent House Property: 123456 ║ ║ Contact: Tom Johnson Phone: 555-555-1212 ║ ║ Address: 1234 Easter Lane Road Picture: ║ ║ Data File: D123456 ║ ║ City/State/Zip: NEW ORLEANS, LA 99999-9999 Unit File: U123456 ║ ║ Type: XXX Class: XXX Date: 01/12/92 Last Date: 12/12/91 < Notes > ║ ╟────────────────[ SELECT EXPENSE OR BILL DESCRIPTION/NAME ]─────────────────╢ ║ NAME ║ ║────────────────────────────────────────────────────────────────────────────║ ║ Advertising - Magazine ║ ║ Advertising - Newspaper ║ ║ Advertising - Other ║ ║ Advertising - Radio ║ ║ Advertising - TV ║ ║ Capital Improvements ║ ║ Cash Dividend ║ ║ Computer Supplies ║ ║ Entertainment ║ ║ Equipment Maintenance ║ ║ Gas & Electric ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Select) Ctrl N (Add) Ctrl U (Del) F5 (Find) 1/37 DAYO Property Management, TJS LAB, Inc. Page: 22 Press enter on the desired expense table record to bring up an input screen for the expense. ╔════════════════[ INPUT EXPENSE OR BILL RECORD/TRANSACTION ]════════════════╗ ║ Name: Rent House Property: 123456 ║ ║ Contact: Tom Johnson Phone: 555-555-1212 ║ ║ Address: 1234 Easter Lane Road Picture: ║ ║ Data File: D123456 ║ ║ City/State/Zip: NEW ORLEANS, LA 99999-9999 Unit File: U123456 ║ ║ Type: XXX Class: XXX Date: 12/12/91 Last Date: 12/12/91 < Notes > ║ ╟─────────────────[ ENTER INFORMATION & AMOUNT OF EXPENSE ]──────────────────╢ ║ Type/Name of Expense -> Advertising - Magazine ║ ║ Unit: EXPENSE Name: Advertising - Magazine Date: 07/26/92 ║ ║ ║ ║ Check Number: 10002 ║ ║ Amount: 0.00 ║ ║ Type: REN ║ ║ Comments: ║ ║ ║ ║ ████ ██ ██ ██▄███ ████ ██ ██ ████ ████ ║ ║ ██ ██ ██ ██ ██ ██ ███▄ ██ ██ ██ ║ ║ ▄▄▄▄▄▄ ███ ███ ██████ ███ ███████ ████ ███ ▄▄▄▄▄▄ ║ ║ ██ ██ ██ ██ ██ ██ ▀███ ██ ██ ║ ║ ████ ██ ██ ██ ████ ██ ██ ████ ████ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) Enter/Return (Select Option) 1/37 ■ SERVICE BROWSE The browse/maintenance of the service records is the fourth option on the main menu. Use this menu option to create, edit and maintain service records (work orders). DAYO Property Management, TJS LAB, Inc. Page: 23 ■ MAINTAIN SERVICE & MAINTENANCE RECORDS The options available while browsing the service records are adding new records, editing records, deleting records, printing a service record, closing a service record, and finding a service record. ╔═══[ Work Order: 0 ]═══════════════════════════════════════════════════╗ ║ Property: 1 Unit: A1 Date Opened: 07/03/92 ║ ║ Contact: RICK LAROSSA Date Completed: / / ║ ║ Cost: 0.00 Closed? No ║ ║ Comments: ║ ╟─────────────────[ MAINTAIN SERVICE & MAINTENANCE RECORDS ]─────────────────╢ ║ WO PROPERTY UNIT CONTACT ║ ║────────────╥──────────╥──────────────╥─────────────────────────────────────║ ║ 10000 ║ 1 ║ A1 ║ RICK LAROSSA ║ ║ 10001 ║ 3 ║ F39 ║ SALLY SMITH ║ ║ 10002 ║ 1 ║ B3 ║ GEORGE MOONILAL ║ ║ 10003 ║ 1 ║ A100 ║ SAM ESPADEEDO ║ ║ 10004 ║ 2 ║ A102 ║ JOSE WELLS ║ ║ 10005 ║ 3 ║ E4B ║ RALPH CRAMDEN ║ ║ 10006 ║ 4 ║ D1 ║ LUCY DELORES MORGAN ║ ║ 10007 ║ 1 ║ C1 ║ RICKY RECARDO ║ ║ 10008 ║ 21 ║ B23 ║ MICKEY MOUSE ║ ║ 10009 ║ 1 ║ B3 ║ SAMMY DAVIS JUNIOR ║ ║ 10010 ║ 2 ║ B1 ║ HERMAN JOHNSON ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F2 (Edit) Ctrl N (Add) Ctrl U (Del) F5 (Find) Alt N (Notes) Alt P (Print) Alt F1 (Close) 1/14 ■ FULL SCREEN EDIT - SERVICE.DBF Press F2 to edit all fields in the currently highlighted record. ┌──────────────────────[ FULL SCREEN EDIT - SERVICE.DBF ]────────────────────┐ │ WO: 1000 │ │ PROPERTY: 1 │ │ UNIT: A1 │ │ CONTACT: RICK LAROSSA │ │ COMMENTS: │ │ DATE: 07/03/92 │ │ COMPLETED: / / │ │ CLOSED: F │ │ COST: 1240.00 │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO Property Management, TJS LAB, Inc. Page: 24 ■ ADD NEW SERVICE RECORD - SERVICE.DBF Press Ctrl N to add/create a new service record. ┌──────────────────[ ADD NEW SERVICE RECORD - SERVICE.DBF ]──────────────────┐ │ │ │ Enter Work Order: 5 │ │ │ │ Property: 0 │ │ Unit: │ │ Date Opened: 07/26/92 │ │ │ │ Contact: │ │ │ │ Comments: │ │ │ │ Cost: 0.00 │ │ Date Completed: / / │ │ Closed? N │ │ │ │ █████ █████ ██████ ██ ██ ████ █████ █████ │ │ ██ ██ ██ ██ ██ ██ ██ ██ ██ │ │ █████ ████ ██████ ██ ██ ██ ██ ████ │ │ ██ ██ ██ ██ ████ ██ ██ ██ │ │ █████ █████ ██ ███ ██ ████ █████ █████ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) Enter (Select) ■ FIND SERVICE ORDER Press F5 to locate a service order based on the work order number. ┌─────────────────────────────────────────────────────────────┐ │ Enter WO: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Property Management, TJS LAB, Inc. Page: 25 ■ EDIT SERVICE NOTES FOR WORK ORDER Press Alt N to record any information specific to the currently highlighted service record. ┌───────────────────[ EDIT SERVICE NOTES FOR WORK ORDER: 0 ]─────────────────┐ │Type in anything you want (up to 18 pages), ie: │ │The facets are broke in the master bedroom. │ │Ordered them on 08/01/92. Expect to install them by the end of the month: │ │31 August 1992 │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) ■ SERVICE & MAINTENANCE WORK ORDER EXAMPLE Press Alt P to print a service and/or maintenance work order. ---------------------------------------- --- SERVICE & MAINTENANCE WORK ORDER --- ---------------------------------------- Your Company Name Date: 07/26/92 5104 N. Orange Blossom Trail Suite 200 Orlando, FL 32810 (407) 291-3960 ------------------------------------------------------------------------------ Work Order: 0 Property: 1 Unit: A1 Date Opened: Friday, 3 July 1992 Contact: RICK LAROSSA Comments: Cost: 0.00 Date Completed: Closed? No ------------------------------------------------------------------------------ Notes Follow: ------------------------------------------------------------------------------ The facets are broke in the master bedroom. Ordered them on 08/01/92. Expect to install them by the end of the month: 31 August 1992 DAYO Property Management, TJS LAB, Inc. Page: 26 ■ REPORTS The reports menu contains many reports. DAYOPROP Version 1.0, Copyright(c) 1992 TJS LAB, Inc ┌─────[July 1992]────┐ ╔═════════════════════════════╗ │S M T W T F S │ ║ PROPERTY MANAGEMENT REPORTS ║ ├────────────────────┤ ║ Printer Setup ║ │ 1 2 3 4│ ║ Unit Activity ║ │ 5 6 7 8 9 10 11│ ║ Unit Vacancy ║ │12 13 14 15 16 17 18│ ║ Unit Late Rent ║ │19 20 21 22 23 24 25│ ║ Unit Lease Date ║tines │26 27 28 29 30 31 │ ║ Unit Roll ║ │ │ ║ Unit Labels ║ └────────────────────┘ ║ Unit Expanded ║═════╦════════════[ Active Property ]═════════╗ ║ Income & Expense ║███░ ║ Rent House (123456) ║ ║ Property List ║ ██░ ║ tom johnson ║ ║ Property Labels ║ ██░ ║ 1234 easter lane, road #2 ║ ║ Property Expanded ║ ██░ ║ NEW ORLEANS, LA 99999-9999 ║ ║ Service List ║███░ ║ ║ ║ Service Expanded ║ ╚════════════════════════════════════════╣ ║ Config Status ║██░ ████░ ██▄███░ ██████░ ██░ ██░ ║ ║ View Reports On Screen ║██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ║██░ ███░ ██████░ ██░ ██████░ Management║ ║ ║ ██░ ██░██░ ██░ ██░ ║ ║ ║ ████░ ██░███░ ██░ ██░ ║ ║ SELECT REPORT ║══════════════════════════════════════════════╝ ╚═════════════════════════════╝ Esc (Exit) Enter/Return (Select Report Option) DAYO Property Management, TJS LAB, Inc. Page: 27 ■ PRINTER DRIVER (SETUP) This routine was added to allow you to change the printer setup. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO Property Management, TJS LAB, Inc. Page: 28 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO Property Management, TJS LAB, Inc. Page: 29 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO Property Management, TJS LAB, Inc. Page: 30 ■ ACTIVITY REPORT This report lists all transaction records for the default property. Multiple indexes include: DATE, UNIT, NAME and CHECKNO. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This is the Activity Report for the current property. ║ ║ All transactions for the property are printed within a date range. ║ ║ Uses Report Form: ACTIVITY.FRM ║ ║ Options include: output to printer or file, multiple indexes, ║ ║ and date range. ║ ║ ║ ║ Select Index ->Date ║ ║ Unit ║ ║ Name ║ ║ Checkno ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ╔════════════════════════════════════════════════════════════════════════════╗ ║ This is the Activity Report for the current property. ║ ║ All transactions for the property are printed within a date range. ║ ║ Uses Report Form: ACTIVITY.FRM ║ ║ Options include: output to printer or file, multiple indexes, ║ ║ and date range. ║ ║ ║ ║ Select Index ->Date ║ ║ ║ ║ Start Date: 06/26/92 End Date: 07/26/92 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: ACTIVITY.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 31 ■ EXAMPLE OF THE ACTIVITY REPORT Page No. 1 Your Company Name Property: Rent House (123456) 07/26/92 ACTIVITY REPORT --------------- Unit Name Check Amount Date Comments ------------ -------------------- ---------- ------------ -------- ---------- EXPENSE Capital Improvements 12323 -134.00 07/20/92 Equipment EXPENSE Supplies 51255 -72.30 07/20/92 Dry Wall A34 Rent 152 123.00 07/20/92 Late! EXPENSE Office Supplies 22521 -68.00 07/20/92 Paper EXPENSE Telephone 32521 -48.00 07/22/92 A35 Rent 312 123.00 07/22/92 EXPENSE Capital Improvements 5345 -4.00 07/22/92 Paint A93 Rent 215 434.00 07/23/92 A930 Rent 853 412.00 07/26/92 C30 Rent 235 101.00 07/26/92 A31 Rent 789 101.00 07/26/92 EXPENSE Advertising - 10002 -200.00 07/26/92 Magazine *** Total *** 767.70 DAYO Property Management, TJS LAB, Inc. Page: 32 ■ VACANCY REPORT This report lists all of the units with their vacancy dates. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This is the Vacancy Report for the current property. ║ ║ Uses Report Form: VACANCY.FRM ║ ║ Options include: output to printer or file, upcoming vacancies, ║ ║ and the start date. ║ ║ ║ ║ Do you wish to include units about to be vacant? (Y/N) ║ ║ ║ ║ Enter number of days to include: 0 ║ ║ ║ ║ Enter Today's Date (Start Date of Report): 07/26/92 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: VACANCY.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ EXAMPLE OF THE VACANCY REPORT Page No. 1 Your Company Name Start Date: Sunday, 26 July 1992 Property: Rent House (123456) 07/26/92 VACANCY REPORT -------------- Rent or Date Unit Name Amount Vacant ------------ ------------------------------ ------------ -------- 234234 Tom Johnson 512.00 01/15/93 __________ 234235 Sally Morgan 434.00 12/15/92 __________ 234236 George Moonilal 423.00 12/15/92 __________ *** Total *** 1369.00 DAYO Property Management, TJS LAB, Inc. Page: 33 ■ LATE RENT REPORT The late rent report lists all of the units that are late with their payments. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This is the Late Rent or Amount Report for the current property. ║ ║ Uses Report Form: LATERENT.FRM ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Enter DUE Date: 07/01/92 ║ ║ ║ ║ Select Index ->Unit ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: LATERENT.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) There are many ways this report can produce an error, so be sure to check it out. ┌─────────────────────────────────────────────────────────────────────────┐ │┌───────────────────────────────────────────────────────────────────────┐│ ││┌─────────────────────────────────────────────────────────────────────┐││ │││ │││ │││ *** DON'T BE FOOLED! *** │││ │││ ───────────────────────────────────────────── │││ │││ This report can be 'fooled' since it uses the │││ │││ last payment date field (LASTPAY) in computing whether │││ │││ a unit is late with the rent/amount... │││ │││ ────────────────────────────────────── │││ ││└─────────────────────────────────────────────────────────────────────┘││ │└───────────────────────────────────────────────────────────────────────┘│ └─────────────────────────────────────────────────────────────────────────┘ Press any key to continue... DAYO Property Management, TJS LAB, Inc. Page: 34 ■ EXAMPLE OF THE LATE RENT REPORT Page No. 1 Your Company Name Property: Rent House (123456) 07/26/92 LATE RENT OR AMOUNT REPORT -------------------------- Rent or Last Unit Name Amount Payment ------------ ------------------------------ ------------ -------- A1 George Moonilal 500.00 02/02/45 *** Total *** 500.00 ■ RENEWAL OR LEASE DATE REPORT This routine is a simple list of all units for the current property and their End Dates (Renewal Dates). ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is a simple list of all units for the current property ║ ║ and their End Dates (Renewal Dates). Uses Report Form: RENEWAL.FRM ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ Select Index ->Unit ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: RENEWAL.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 35 ■ EXAMPLE OF THE LEASE RENEWAL REPORT Page No. 1 Your Company Name Property: Rent House (123456) 07/26/92 LEASE RENEWAL REPORT -------------------- Rent or Renewal Unit Name Comments Amount Date ------------ ------------------------------ ------------ ------------ -------- 234234 Tom Johnson 512.00 01/15/93 234235 Salley Morgan 434.00 12/15/92 234236 George Moonilal 423.00 12/15/92 *** Total *** 1369.00 ■ ROLL REPORT This routine is a simple list of all units for the current property and their Amount (Rent), Security and End Dates (Renewal Dates). ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is a simple list of all units for the current property ║ ║ and their Amount (Rent), Security and End Dates (Renewal Dates). ║ ║ Very similar to the Renewal Report. Uses Report Form: ROLL.FRM ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Unit ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: ROLL.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 36 ■ EXAMPLE OF THE ROLL REPORT Page No. 1 Your Company Name Property: Rent House (123456) 07/26/92 ROLL REPORT ----------- Rent or Security Renewal Unit Name Amount Deposit Date Comments ------- -------------------- ------------ ------------ -------- -------------- 234234 Tom Johnson 512.00 200.00 01/15/93 Wants to renew if porch fixed 234345 Salley Morgan 434.00 200.00 12/15/92 234236 George Moonilal 423.00 250.00 12/14/92 *** Total *** 1369.00 650.00 ■ UNIT MAILING LABELS This option prints a mailing label for all units or a specific unit. ╔═══════════════════════════════════════════════════════╗ ║ Use this option to print the UNIT mailing address ║ ║ labels. The address label is the standard size of ║ ║ 3.5x15/16, 6 LPI. ║ ║ ║ ║ ╒══════════════════════════════╕ ║ ║ │Tom Johnson │ ║ ║ │5104 N. OBT │ ║ ║ │Suite 200 │ ║ ║ │Orlando, FL 32810 │ ║ ║ │ │ ║ ║ ╘══════════════════════════════╛ ║ ║ UNIT NAME ║ ║ 234234 Tom Johnson ║ ║ 234235 Sally Morgan ║ ║ 234236 Herman Munster ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Esc (Exit) Enter (Print) F3(ALL) F5/F6(Find) ║ ╚═══════════════════════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 37 ■ UNIT EXPANDED REPORT Fields included on the Unit Expanded report are: Unit, name & address, phone, rent amount, security deposit, last payment date, last pay date, date record created, renewal date, type, class, picture file name, and comments. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This Expanded Unit Report is a wide report (157 characters). ║ ║ It contains all the key fields found in the Unit Database: u123456 . ║ ║ Uses Report Form: UNITEXP.FRM ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Unit ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: UNITEXP.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ INCOME & EXPENSE REPORT This report option prints a simple income & expense report including all of the transactions for the default property grouped by class and name. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This is the Income & Expense Report for the current property. ║ ║ All transactions for the property are printed within a date range. ║ ║ Uses Report Form: INCOME.FRM. Note, a special index is created. ║ ║ Options include: output to printer or file and date range. ║ ║ ║ ║ Start Date: 06/03/92 End Date: 07/23/92 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: INCOME.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 38 ■ EXAMPLE OF THE INCOME & EXPENSE REPORT Page No. 1 Your Company Name Property: Rent House (123456) 07/26/92 INCOME & EXPENSE ---------------- Date Check Comments Income Expense -------- ------------ ------------------------------ ------------ ------------ ** Name/Description: Rent 03/01/92 1244 500.00 0 04/01/92 1289 500.00 0 05/12/92 1329 Late 525.00 0 06/01/92 1456 500.00 0 07/01/92 1567 500.00 0 08/01/92 1599 500.00 0 ** Subtotal ** 3025.00 0 ** Name/Description: Advertising - Magazine 07/26/92 10002 0 100.00 ** Subtotal ** 0 100.00 ** Name/Description: Capital Improvements 07/20/92 10020 Dry Wall 0 60.00 07/22/92 10455 Nails, hammer & tools 0 340.00 ** Subtotal ** 0 400.00 *** Total *** 3025.00 500.00 DAYO Property Management, TJS LAB, Inc. Page: 39 ■ PROPERTY LIST This report produces a list including all of your properties. The multiple indexes include: PROPERTY, NAME, ADDRESS, PHONE & CONTACT ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is a simple list of all your properties. ║ ║ Uses Report Form: PROPLIST.FRM ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Property ║ ║ Name ║ ║ Address/Street ║ ║ ║ ║ Send Output t Contact ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is a simple list of all your properties. ║ ║ Uses Report Form: PROPLIST.FRM ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Property ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PROPLIST.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 40 ■ EXAMPLE OF THE PROPERTY LIST Page No. 1 Your Company Name Property: George House (2340) 07/26/92 PROPERTY LIST ------------- Name Original Last Property Address & Phone Date Date Type Class -------- ------------------------------ -------- -------- ---- ----- 1 Sal Moore Hotel & Boarding 01/22/92 07/04/92 REN REN ________ 2 Tom House East River Road 02/28/92 07/05/92 REN REN ________ Phone: 555-555-1212 3 George Moonilal Properties 12/12/91 07/12/92 XXX XXX ________ 4 Werewolf Cove Manor 07/18/91 07/23/92 REN REN ________ 5 Howdy Hotel 07/18/91 07/18/92 REN REN ________ 6 Rent House 12/12/91 07/22/92 REN REN ________ Tom Johnson 1234 Easter Lane Road #2 NEW ORLEANS, LA 32810-5200 Phone: 555-555-1212 ■ PROPERTY MAILING LABELS Use this routine to print labels for all or a single property. ╔═══════════════════════════════════════════════════════╗ ║ Use this option to print the PROPERTY mailing address ║ ║ labels. The address label is standard size of ║ ║ 3.5x15/16, 6LPI. ║ ║ ║ ║ ╒══════════════════════════════╕ ║ ║ │George Moonilal Properties │ ║ ║ │100 Lastline Road │ ║ ║ │Building 199 │ ║ ║ │New South City, CA 92929 │ ║ ║ │ │ ║ ║ ╘══════════════════════════════╛ ║ ║ PROPERTY NAME ║ ║ 1 Samual House ║ ║ 2 Tom House ║ ║ 3 George Moonilal Properties ║ ║ 4 Wells Farley Hotel ║ ║ 5 Down House ║ ║ 6 Rent House ║ ║ ║ ║Esc (Exit) Enter (Print) F3(ALL) F5/F6/F7/F8/F9 ║ ╚═══════════════════════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 41 ■ PROPERTY EXPANDED REPORT This report contains all the key fields for all properties. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is the Expanded Property Report, that lists all the ║ ║ key property record fields. Uses Report Form: PROPERTY.FRM. ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Property ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PROPERTY.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 42 This report contains the following fields: Property number, name & address, telephone number, fax number, contact name, original date, last date, type, class, date file name, unit file name, and picture file name. ■ SERVICE/WORK ORDER LIST This routines prints a list of all your service work orders. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is a simple list of all your service work orders. ║ ║ Uses Report Form: SERLIST.FRM. ║ ║ Options inclu ║ ║ Select Index ->Work Order ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is a simple list of all your service work orders. ║ ║ Uses Report Form: SERLIST.FRM. ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Work Order ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: SERLIST.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 43 ■ EXAMPLE OF THE SERVICE LIST Page No. 1 Your Company Name Property: Rent House (123456) 07/26/92 SERVICE LIST ------------ Work Original Date Order Property Unit Comments Cost Date Completed ------ -------- ---------- -------------------- ---------- -------- --------- 0 1 A3 BROKEN MIRROR 25.00 07/03/92 07/26/92 0 5 D5 RESET DOOR FRAME 0.00 07/19/92 07/19/92 1 3 D34 BROKEN WINDOW 10.00 07/19/92 07/19/92 2 3 A34 REPLACE DRAPES 40.00 07/19/92 07/19/92 4 4 G1 PAINT APARTMENT 400.00 07/19/92 07/19/92 *** Total *** 475.00 ■ EXPANDED SERVICE REPORT This report prints all the key fields for your service work orders. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine is the Expanded Service Report that lists all the key ║ ║ service record fields. Uses Report Form: SERVICE.FRM. ║ ║ Options include: output to printer or file and multiple indexes. ║ ║ ║ ║ Select Index ->Work Order ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File ) ║ ║ ║ ║ Enter File Name: SERVICE.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Property Management, TJS LAB, Inc. Page: 44 The service expanded report contains the following fields: Work order, property number, unit number, contact name, comments, cost, original date, date completed, and open/closed status. ■ CONFIGURATION REPORT This report lists all of the configuration settings/values. Be sure to print and save one of these reports in case you ever need to restore it. ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOPROP.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CONFIGURATION REPORT +++++++++++++++++++++++++++++++++++++++++++++++++ + DAYO PROPERTY MANAGEMENT CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++++++++ 07/26/92 17:06:56 Company Name: Your Company Name Address Line 1: 5104 N. Orange Blossom Trail Address Line 2: Suite 200 City: Orlando State: FL Zip: 32810 Telephone: (407) 291-3960 Current Database Location: Default CLASS Code: REN Default TYPE Code: REN Print Receipt Voucher: No Report Printer Type: STANDARD PRINTER Report Printer Port: LPT1 Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes DAYO Property Management, TJS LAB, Inc. Page: 45 ■ VIEW REPORTS ON SCREEN Use this routine to view reports previously written to disk. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO Property Management, TJS LAB, Inc. Page: 46 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines displays the function keys. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYORPT View Reports │ File Name: COA.TXT DAYO Property Management, TJS LAB, Inc. Page: 47 Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2" GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO Property Management, TJS LAB, Inc. Page: 47 ■ CONFIGURATION All configuration settings are found in this main menu routine. ╔══════════════════════════════════╗ ║ CONFIGURATION ║ ╟──────────────────────────────────╢ ║ Company Name ║ ║ Address ║ ║ City ║ ║ State ║ ║ Zip ║ ║ Telephone ║ ║ Current Database Location ║ ║ Default TYPE ║ ║ Default CLASS ║ ║ Print Receipt Voucher ║ ║ Report Printer Type ║ ║ Report Printer Port ║ ║ Auto Daily Index ║ ║ Color ║ ║ Intensity ║ ║ ║ ║ ║ ╟──────────────────────────────────╢ ║ Select Option ║ ╚══════════════════════════════════╝ ■ COMPANY NAME Enter up to 30 characters containing your company name. ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: Your Company Name │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ADDRESS Enter up to 30 character each for 1 or 2 lines of address. ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: 5104 N. Orange Blossom Trail │ │ Address Line 2: Suite 200 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 48 ■ COMPANY CITY Enter up to 20 characters for your city. If you are located outside of the United States, then use this field to include provinces. ┌──────────────────────────────[ COMPANY CITY ]──────────────────────────────┐ │ City: Orlando │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY STATE Enter a valid 2 digit state code, or leave blank if you are located outside the United States. ┌─────────────────────────────[ COMPANY STATE ]──────────────────────────────┐ │ State: FL │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ZIP Enter your zip or postal code (up to 10 digits). ┌──────────────────────────────[ COMPANY ZIP ]───────────────────────────────┐ │ Zip Code: 32810 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY TELEPHONE Enter you telephone number (up to 14 characters). ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: (407) 291-3960 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 49 ■ CURRENT DIRECTORY DATABASE LOCATION Enter the location (directory and/or drive) of your property management databases if they are not in the current directory. ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOPROP\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT TYPE CODE Enter the default type code used when adding property and unit records. ┌───────────────────────────[ DEFAULT TYPE CODE ]────────────────────────────┐ │ Enter Your Default TYPE Code: REN │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT CLASS CODE Enter the default class code used when adding property and unit records. ┌───────────────────────────[ DEFAULT CLASS CODE ]───────────────────────────┐ │ Enter Your Default CLASS Code: REN │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT RENT/LEASE RECEIPT VOUCHER If you want to print a receipt voucher for rent, security, sale or miscellaneous income receipt, then select Y (Yes). ┌────────────────────[ PRINT RENT/LEASE RECEIPT VOUCHER ]────────────────────┐ │ If this option is set to Y (YES), you will be prompted to print a │ │ receipt each time you receive a payment for rent or security. │ │ │ │ Print Rent Receipt Voucher? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 50 ■ REPORT PRINTER TYPE This is the default printer type: STANDARD or LASER. ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is an Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT All reports printed to the printer will be directed to this port. ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATIC DAILY INDEXING By default, all databases are reindexed each day, which we highly recommend. ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO Inventory will be recreated once daily. This will occur when the │ │ first DAYO Inventory program is run. The default is to recreate all │ │ all the indexes daily... │ │ │ │ Recreate all DAYO Inventory Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 51 ■ COLOR MONITOR If you have a color monitor, select Y (Yes) to this option. ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY If you want high intensity color, the press Y (Yes) to this option. ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 52 ■ MISCELLANEOUS ROUTINES The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC Routines Menu: DAYOPROP Version 1.0, Copyright(c) 1992 TJS LAB, Inc ┌─────[July 1992]────┐ ╔════════════════════╗perty │S M T W T F S │ ║ MISC ROUTINES ║come ├────────────────────┤ ╟────────────────────╢╔════════════[ B E C A R E F U L ! ]═══════════════╗ ║ APPEND FROM ║║ This menu option provides you with a multitude of ║ ║ BROWSE DATABASES ║║ database management tools and functions, but also ║ ║ COPY (.DBF) TO ║║ can be a source of significant problems! ║ ║ CREATE DATABASE ║║ ║ ║ DELETE RECORDS ║║ Miscellaneous Routines was provided to give you a ║ ║ ERASE FILE ║║ 'back door' to DAYO, but if used incorrectly, it ║ ║ EXIT TO DOS ║║ can damage or destroy your data! ║ ║ INDEX A DATABASE ║║ ║ ║ LIST FIELDS ║║ Adding records to databases, packing, appending, ║ ║ PACK DATABASE ║║ editing records and modify databases can ║ ║ MODIFY DATABASE ║║ corrupt the indexes related to the database(s)! ║ ║ RECALL RECORDS ║║ You must know to reindex (Alt F9) if you do any ║ ║ RETURN TO MENU ║║ of these operations... ║ ║ RUN (DOS COMMAND) ║║ ║ ║ SIMPLE EDITOR ║║ When modifying a database, the rule is to NEVER ║ ║ SORT DATABASE ║║ change an existing field; only to add new fields... ║ ║ TYPE (PRINT) FILE ║║ ║ ║ ZAP DATABASE ║║ Remember that 'ZAP' means to remove (permanently) ║ ╟────────────────────╢║ all records in the selected database! ║ ║ Select Option ║╚══════════════════════════════════════════════════════╝ ╚════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 53 ■ APPEND FROM Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 54 If you are appending from another database (.DBF) then select 'Standard'. Select the SDF option if you are appending from a 'flat' ASCII file. Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 55 ■ BROWSE DATABASES Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO Property Management, TJS LAB, Inc. Page: 56 To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO Property Management, TJS LAB, Inc. Page: 57 ■ COPY (.DBF) TO Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO Property Management, TJS LAB, Inc. Page: 58 The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 59 The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO Property Management, TJS LAB, Inc. Page: 60 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO Property Management, TJS LAB, Inc. Page: 61 ■ DELETE RECORDS Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ The number of records deleted will be displayed upon the screen as depicted just above... DAYO Property Management, TJS LAB, Inc. Page: 62 ■ ERASE FILE Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO Property Management, TJS LAB, Inc. Page: 63 ■ INDEX A DATABASE You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 64 At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 65 The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 66 The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 67 The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO Property Management, TJS LAB, Inc. Page: 68 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 69 ■ RECALL RECORDS Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO Property Management, TJS LAB, Inc. Page: 70 ■ SIMPLE EDITOR A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More *** Note, this routine will try to load binary files (.EXE, .OBJ, etc...), so be careful at what you select for viewing/editing. If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO Property Management, TJS LAB, Inc. Page: 71 Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 72 The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 73 The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO Property Management, TJS LAB, Inc. Page: 74 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 75 The eighth routine on the main menu is the display our company address. ╔════════════════════════════════════════════════════════════════════════════╗ ║ This program lets you create and maintain unlimited property records ║ ║ to include the following data: rents, payments, expenses, income, ║ ║ owners, renters, work orders, and much more! ║ ║ This program is multi-user, mouse supported, and even has special VGA ║ ║ graphic routines/maps/pictures. ║ ║ Remember, we can change the program to accomodate your specific needs. ║ ║ ║ ║ ────────────────────────────────────────────────────────────────────── ║ ║ ║ ║ Contact TJS LAB, Inc. for more information at: ║ ║ 5104 North Orange Blossom Trail #200 ║ ║ Orlando, Florida 32810 ║ ║ Sales: (800) 525-DAYO (3296) * Orders Only Please ║ ║ Local Sales: (407) 292-4895 ║ ║ Support: (407) 292-4708/291-3960/291-6987 ║ ║ Fax: (407) 295-2171 ║ ║ BBS: (407) 292-4921 (8-N-1) 2400 -> 9600 V.32 ║ ║ Compuserve: 76367,1401 ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 76 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌──────────────────────[ DAYOPOS HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌───────────────────────[ DAYOPOS HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Property Management, TJS LAB, Inc. Page: 77 - Editor help: ┌──────────────────────[ DAYOPOS HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP Expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO Property Management, TJS LAB, Inc. Page: 78 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO POS Version 4.00 TJS LAB ┌───[February 1992]──┐ ┌──────[ DAYO HELP Called by Program: DAYOPROP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOPOS. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO Property Management, TJS LAB, Inc. Page: 79 DAYO POS Version 4.00 TJS LAB ┌───[February 1992]──┐ ┌───────[ DAYO HELP Called by Program: DAYOPROP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOPROP the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO Property Management, TJS LAB, Inc. Page: 80 ■ DATABASE STRUCTURE ■ DATABASE: PROPERTY.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ───── 1 PROPERTY Numeric 6 1 6 2 NAME Character 30 7 36 3 CONTACT Character 30 37 66 4 ADDRESS Character 30 67 96 5 ADDRESS2 Character 30 97 126 6 CITY Character 20 127 146 7 STATE Character 2 147 148 8 ZIP Character 10 149 158 9 PHONE Character 14 159 172 10 FAX Character 14 173 186 11 DATAFILE Character 8 187 194 12 UNITFILE Character 8 195 202 13 DATE Date 8 203 210 14 LASTDATE Date 8 211 218 15 TYPE Character 3 219 221 16 CLASS Character 3 222 224 17 CONDITION Character 10 225 234 18 PICTURE Character 8 235 242 19 NOTES Memo 10 243 252 ** Total ** 253 ■ DATABASE: UNITFILE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ───── 1 UNIT Character 12 1 12 2 NAME Character 30 13 42 3 PHONE Character 14 43 56 4 SECURITY Numeric 10 2 57 66 5 AMOUNT Numeric 10 2 67 76 6 BEGINDATE Date 8 77 84 7 ENDDATE Date 8 85 92 8 LASTAMOUNT Numeric 10 2 93 102 9 LASTPAY Date 8 103 110 10 LASTDATE Date 8 111 118 11 DATE Date 8 119 126 12 COMMENTS Character 50 127 176 13 PICTURE Character 8 177 184 14 TYPE Character 3 185 187 15 CLASS Character 3 188 190 16 CONDITION Character 10 191 200 17 NOTES Memo 10 201 210 18 ADDRESS Character 30 211 240 19 ADDRESS2 Character 30 241 270 20 CITY Character 20 271 290 21 STATE Character 2 291 292 22 ZIP Character 10 293 302 ** Total ** 303 DAYO Property Management, TJS LAB, Inc. Page: 81 ■ DATABASE: DATAFILE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ───── 1 UNIT Character 12 1 12 2 NAME Character 30 13 42 3 CHECKNO Character 12 43 54 4 AMOUNT Numeric 12 2 55 66 5 BALANCE Numeric 12 2 67 78 6 SECURITY Numeric 12 2 79 90 7 DATE Date 8 91 98 8 TYPE Character 3 99 101 9 CLASS Character 3 102 104 10 BY Character 10 105 114 11 COMMENTS Character 50 115 164 ** Total ** 165 ■ DATABASE: SERVICE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ───── 1 WO Numeric 6 1 6 2 PROPERTY Numeric 6 7 12 3 UNIT Character 12 13 24 4 CONTACT Character 30 25 54 5 COMMENTS Character 50 55 104 6 DATE Date 8 105 112 7 COMPLETED Date 8 113 120 8 CLOSED Logical 1 121 121 9 COST Numeric 10 2 122 131 10 NOTES Memo 10 132 141 ** Total ** 142 DAYO Property Management, TJS LAB, Inc. Page: 82 ■ DATA DICTIONARY Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── ADDRESS C 30 0 PROPERTY.DBF Property address line 1 UNITFILE.DBF Unit address line 1 ADDRESS2 C 30 0 PROPERTY.DBF Property address line 2 UNITFILE.DBF Unit address line 2 AMOUNT N 10 2 UNITFILE.DBF Amount of rent AMOUNT N 12 2 DATAFILE.DBF Amount of transaction BALANCE N 12 2 DATAFILE.DBF Balance of property income & expenses BEGINDATE D 8 0 UNITFILE.DBF Date unit begin (first date rented) BY C 10 0 DATAFILE.DBF User that created the transaction CHECKNO C 12 0 DATAFILE.DBF Check number CITY C 20 0 PROPERTY.DBF UNITFILE.DBF CLASS C 3 0 DATAFILE.DBF Class code for transaction. Must be either 'INC' (for income), or 'EXP' (for expense) UNITFILE.DBF Class code, user defined PROPERTY.DBF CLOSED L 1 0 SERVICE.DBF Status of service work order. Open equals .T. COMMENTS C 50 0 UNITFILE.DBF DATAFILE.DBF SERVICE.DBF COMPLETED D 8 0 SERVICE.DBF Date the service work order was completed and/or closed CONDITION C 10 0 PROPERTY.DBF Condition of the property or unit UNITFILE.DBF CONTACT C 30 0 PROPERTY.DBF Name of the contact SERVICE.DBF COST N 10 2 SERVICE.DBF Cost of the service work order DATAFILE C 8 0 PROPERTY.DBF Name of the transaction database DATE D 8 0 DATAFILE.DBF Date record was created PROPERTY.DBF UNITFILE.DBF SERVICE.DBF ENDDATE D 8 0 UNITFILE.DBF Date to be vacant FAX C 14 0 PROPERTY.DBF Fax telephone number LASTAMOUNT N 10 2 UNITFILE.DBF Last amount paid LASTDATE D 8 0 PROPERTY.DBF Last date record was accessed UNITFILE.DBF LASTPAY D 8 0 UNITFILE.DBF Last pay NAME C 30 0 DATAFILE.DBF Name of the expense or income UNITFILE.DBF Name of person in the unit PROPERTY.DBF Name of the property DAYO Property Management, TJS LAB, Inc. Page: 83 ■ DATA DICTIONARY CONTINUED... Field Name Type Len Dec Database Comments ──────────── ──── ─── ─── ──────────── ──────────────────────────────────── NOTES M 10 0 SERVICE.DBF Service notes UNITFILE.DBF Unit notes PROPERTY.DBF Property notes PHONE C 14 0 PROPERTY.DBF Telephone number UNITFILE.DBF PICTURE C 8 0 PROPERTY.DBF Not used UNITFILE.DBF PROPERTY N 6 0 SERVICE.DBF Property number PROPERTY.DBF SECURITY N 12 2 DATAFILE.DBF Security deposit amount SECURITY N 10 2 UNITFILE.DBF Security deposit amount STATE C 2 0 UNITFILE.DBF PROPERTY.DBF TYPE C 3 0 PROPERTY.DBF Type code, user defined DATAFILE.DBF UNITFILE.DBF UNIT C 12 0 UNITFILE.DBF Unit number DATAFILE.DBF SERVICE.DBF UNITFILE C 8 0 PROPERTY.DBF Name of unit database WO N 6 0 SERVICE.DBF Work order number ZIP C 10 0 PROPERTY.DBF Zip code and/or postal code UNITFILE.DBF DAYO Property Management, TJS LAB, Inc. Page: 84 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB, Inc. 5104 North Orange Blossom Trail Suite 200 Orlando, FL 32810 Call us at: (407) 291-DAYO (3296) Use our BBS: (407) 292-4921 (8-N-1) Fax us at: (407) 295-2171